l107/H16 Ajax/leerlingenza.php

<?php if($_GET['llnr']){ $llnr=$_GET['llnr']; } ?> <!DOCTYPE html> <html lang="en"> <head> <script src="ajax.js"></script> <link href="ajax.css" rel="stylesheet" type="text/css"> <title>Leerlingen zonder ajax</title> <script> window.onload = setEvents function setEvents(){ document.getElementById('llnr').onchange = leerlingChange } function leerlingChange(){ var llnr =this.options[this.selectedIndex].value; document.location='?llnr=' + llnr; } </script> </head> <body> <?php include('../db.php');//verbinding database echo "<div><span class='veldnaam'>Leerling:</span>"; ?> <select name='llnr' id='llnr'> <option value=''></option> <?php //alle auteurs ophalen $query ="select * from leerlingen order by achternaam"; $result = mysqli_query($db, $query) or die(mysqli_error($db).": $query"); while($row = mysqli_fetch_array($result)){ $selected = $llnr == $row['llnr']?"selected":""; echo "<option $selected value='$row[llnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>\n"; } echo "</select></div>"; if($llnr){ include('leerlingdetailsza.php'); } ?> <hr> <p><input type="checkbox" id='alertRespons'>Alert antwoord</p> <div id='ajaxtext'></div> </body> </html>

Resultaat

Made by Thijs Aarnoudse